﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MesGLApp.DAL.MesDB
{
    [Serializable]
    [Table("smt_pcb_confirm")]
    [SugarTable("smt_pcb_confirm")]
    public class SmtPcbConfirm
    {
        /// <summary>
        /// id，主键，自增长
        /// </summary>
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int id { get; set; }

        /// <summary>
        /// 工单ID，引用target_prod_process表ID
        /// </summary>
        public int prod_id { get; set; }

        /// <summary>
        /// 工单号
        /// </summary>
        public string prod_number { get; set; }

        /// <summary>
        /// 物料编号（PCB板）
        /// </summary>
        public string mat_number { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        public string mat_name { get; set; }

        /// <summary>
        /// 物料规格
        /// </summary>
        public string mat_spe { get; set; }

        /// <summary>
        /// 需求数量
        /// </summary>
        public decimal? neet_qty { get; set; }

        /// <summary>
        /// 实领数量
        /// </summary>
        public decimal? picked_qty { get; set; }


        /// <summary>
        /// 已确认过数量
        /// </summary>
        public decimal? clear_qty { get; set; }


        /// <summary>
        /// 确认数量
        /// </summary>
        public decimal? confirm_qty { get; set; }

        /// <summary>
        /// 建档人
        /// </summary>
        public string create_user { get; set; }

        /// <summary>
        /// 建档日期
        /// </summary>
        public DateTime? create_date { get; set; }

        /// <summary>
        /// 更新人
        /// </summary>
        public string update_user { get; set; }

        /// <summary>
        /// 更新日期
        /// </summary>
        public DateTime? update_date { get; set; }
    }
}
